SQL Developer Release Notes

History of Changes

• Version 2.3.0
• Version 2.2.0
• Version 2.1.0
• Version 2.0.0
• Version 1.16
• Version 1.15
• Version 1.14
• Version 1.13
• Version 1.12
• Version 1.11
• Version 1.10
• Version 1.09
• Version 1.08
• Version 1.07
• Version 1.06
• Previous Versions

Version 2.3.0

• Data export wizard supporting multiple output formats:
  • SQL - Creates a SQL insert script that can be run against a database.
  • CSV - Creates a CSV (Comma Separated Values) list that can be used in a spreadsheet.
  • XML- Creates a XML document that can be transformed to various other formats.
  • HTML - Creates a HTML document that can be inserted in most office applications.
• Oracle enhancements:
  • Tablespace analyser.
  • Asynchronous execution of explain plan.
  • Session info now shows old and current SQL statement.
• New database connector for H2.
• Driver settings dialog allows to enable/disable driver archives.
• Several minor improvements and bug fixes.

Version 2.2.0

• The connector chooser dialog provides access to an integrated port scanner to search for open ports on database servers.
• In addition to primary and foreign keys on table columns the database navigator also shows unique keys on columns now.
• Search for software updates of SQL Developer implemented (can be initiated by the user from the help menu).
• The database comparison has been extended to compare constraints, indexes, procedures, functions and triggers.
• Oracle 10g recycle bin extension added to examine and manage dropped objects.
• Graphical Oracle database monitor implemented.
• Graphical Microsoft database monitor implemented.
• In addition to the ODBC/JDBC Bridge driver the Microsoft SQL Server connector now also supports connections via the jTDS driver (without ODBC).
• Microsoft Access shows forms, reports, pages, modules and macros in the database navigator.
• Bug in Microsoft Access view source retrieval added. Expressions are not quoted any more.
• Diagram editor:
  • PNG image file export function implemented.
  • Context menu (right mouse button) in diagram window.
  • Functions added for aligning objects against each other.
  • Improved browser for database object import.
• HTML added as clipboard format for SQL Editors to support colored text.
• Bookmarks:
  • History size can be configured by the user now.
  • Copy bookmark action in SQL statement editor added.
• Query result in SQL statement editor now also visualizes byte arrays.
• System info in about dialog added.
• Several minor improvements and bug fixes.

Version 2.1.0

• Docking desktop.
• History for SQL statements and bookmarks catalog.
• New node in database navigator showing the dependencies of a view.
• Oracle instance parameters are now shown in the database info dialog (visible with DBA privileges only).
• Drag and Drop of text blocks in SQL editors.
• Missing or corrupted driver archives are shown as such in the settings dialog.
• Plugins information in settings dialog.
• Support for look and feel decorations implemented (This decorates title bars and borders of windows).
• Diagram editor:
  • Color choosers now also provide a transparent color.
  • Fixed partial rotated labels.
• Several minor improvements and bug fixes.

Version 2.0.0

• Complete technical redesign.
• Refactored dialog for opening connections:
  • Detailed driver info for each connector plugin.
  • Direct access to class path configuration.
  • Optional user defined name for all connections.
  • Basic connector plugin now allows flexible definition of attributes and retrieves available arguments supported by the driver.
  • Oracle connector plugin now allows to connect as SYSDBA or SYSOPER.
• Unicode support for file I/O.
• Menu with recently opened connections added.
• Tabbed bar added for easy switching between windows.
• Exported keys information for tables in database navigator.
• Basic extension for catalog and schema comparison added.
• Basic extension for dissolving object depencies added.
• New diagram editor with zoom, automatic layout and SVG support.
• Extended quick browse for simple creation of complex joined queries.
• Microsoft SQL Server enhancements:
  • Microsoft SQL Server connector added.
  • Process viewer extension implemented.
  • Server monitor extension implemented.
  • Remote command shell extension added.
• MySQL enhancements:
  • Process viewer extension implemented.
• Oracle enhancements:
  • Filter for sessions extension added.
  • Jobs extension added.
  • Oracle Text (interMedia) extension added.
  • Tablespace usage information in database navigator.
  • User roles and privileges in database navigator.
  • Unique key constraint columns in database navigator.
  • Segments information for various objects.
  • Added missing columns clause in alter trigger function.
• New database connector for Ingres.
• New database connector for Firebird.
• New database connector for Mckoi SQL Database.
• New database connector for Mimer SQL.
• New database connector for PostgreSQL.
• The GO command is now recognized as a statement terminator in SQL script editor.
• Echo output option for commands in SQL script editor.
• Added support for multiple result sets in SQL script editor.
• New find and replace text dialog with regular expressions.
• Clob viewer supports text search, XML syntax highlighting and XML formatting.
• Blob image viewer now supports zooming and allows to copy the displayed image to clipboard.
• Several minor improvements and bug fixes.

Version 1.16

• Window position is no longer stored for minimized or maximized state.

Version 1.15

• Command termintors in SQL Script editor (; or /) can now be turned on and off.
• Bug fix for blob viewer scrolling.

Version 1.14

• Single SQL Editor only executes the selected range of a query if a selection exists.
• Editor syntax highlighting colors can now be configured in the properties dialog.
• DDL extraction of table primary keys implemented.
• DDL extraction of users and table constraints for Oracle implemented.
• SQL Script Editor: Improved parser and single step execution implemented, bug fix for execute command which often started at wrong position.
• Extended Windows PLAF is no longer installed on non-Windows machines as it does only work on Windows OS.
• Image option for blob viewer implemented. Blobs containing images can be viewed within the application. Supported formats: JPEG, GIF and PNG.
• Initial connection info in output window.
• DDL extraction of indices for Oracle implemented.
• DDL extraction of tablespaces for Oracle implemented.
• Display of blob objects in query result sets.

Version 1.13

• New installer to provide JRE 1.4 compatibility for installation.
• First preview of Diagram Editor implemented to visualize tables and relations.
• Display of clob objects in query result sets.
• Dialog resize bug patched for Linux JVMs (Dialogs are always resizable now).
• DDL extraction with multiple selection implemented.
• DDL extraction of sequences for Oracle implemented.
• DDL extraction of views for Access implemented.
• Foreign key indentification for Access implemented.
• Sessions extension for Oracle implemented. The window shows all database sessions and their SQL statements. The user can also kill sessions from there.
• Schema filter for Oracle implemented. A schema is only shown in the database navigator if the user has access to at least one object of that schema.
• ODBC connection component now provides a list of available data source names from the ODBC.ini file.
• Class path order for dynamic driver loading can be configured in the properties dialog.

Version 1.12

• JRE 1.4 compatibility. (Fixed some glitches in syntax highlighting and word completion)
• Online help.
• Tip of the day.
• Drag and drop support for database object identifiers from the Database Navigator into editor windows.
• COUNT(*) function in Single SQL Editor now supports SELECT, UPDATE and DELETE statements.
• Show Plan extension for SQL Server implemented.
• Drop support for Oracle constraints and table columns implemented.
• Foreign key constraints now show the referenced table in Oracle.
• Bug in Stored Procedure Editor for Oracle fixed. (Carriage return line separators caused an error on Windows)

Version 1.11

• Explain Plan extension for Oracle implemented.
• Visualization of Oracle objects Roles, Privileges and Snapshots implemented.
• Bug in Single SQL Editor LOB (BLOB/CLOB) display fixed.

Version 1.10

• Drop support for Oracle objects Package, Package Body and Sequence implemented.

Version 1.09

• Bugs in connection components for MySQL and PointBase fixed (AbstractMethodError).
• Stored Program Editor with error output for Oracle.
• Visualization of running queries in Single SQL Editor.
• Display of 'first fetch time' after query execution in Single SQL Editor.

Version 1.08

• Oracle connection component automatically selects the first TNSNames entry after changing the TNSNAMES.ORA location (sometimes the list was empty).
• A ClassNotFoundException while driver initialization is now displayed with the driver's name and a short note how to solve the problem.

Version 1.07

• Oracle objects data files and rollback segments implemented.
• Warning message when closing editor windows with unsaved content.
• 'Apply' function in properties dialog.
• Preview for Look and Feel switch implemented.
• Bug in context menu on Solaris fixed.
• The about dialog.
• Support of Oracle sequences and tablespaces.
• 'Copy identifier' function in navigator tree implemented.
• Oracle TNSNAMES.ORA is now configurable in connection component.
• Connection profile is now splitted for users and stored in the user home directory.
• DB2/OS390 object sequence implemented.
• Data export supports optional virtual auto increment fields.
• New document windows are opened cascaded.
• Base functions for Cloudscape implemented.
• Data export supports further standard date formats.

Version 1.06

• Support of multiline strings in single quoted literals.
• Current catalog is marked with CURRENT.
• Syntax support for PointBase, ODBC (Jet) and MySQL implemented.
• Support for alteration of Access views.
• Focus bug in navigator tree fixed.
• Header with tooltip in Single Editor result set display.
• Table column widths adjustment in Single Editor result set display. (three variants).

Previous versions

• Simple find and replace function in editors.
• Support for saving output documents.
• Connection control commands added to navigator tree context menu.
• Data export with multiple output formats.
• Visualization of standard class path in properties dialog.
• Dynamic driver loading.
• Properties dialog page for class path configuration.
• Print support.
• Automatic indentation in editor.
• Properties dialog page for editor configuration.